﻿CREATE TABLE [dbo].[StockTransaction] (
    [ID_StockTransaction] INT           IDENTITY (1, 1) NOT NULL,
    [Id_Product]          INT           NOT NULL,
    [DocumentNumber]      VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Description]         VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TransactionDate]     SMALLDATETIME NOT NULL,
    [Id_TransactionType]  INT           NOT NULL,
    [Quantity]            DECIMAL (18)  NOT NULL,
    [Amount]              MONEY         NULL
);

